Speaking this week at #sqlsatChattanooga and for the PASS Performance Virtual Chapter

Comments 0

Share to social media

The topic for both sessions will be: How In-Memory Database Objects Affect Database Design and the following is the abstract:

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn’t that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.

The PASS Performance Virtual Chapter session will be 1:00 PM Central Time on Thursday the 25th. You can see more details and register here: http://performance.sqlpass.org/

The SQL Saturday Chattanooga session will be at 3:00 PM Eastern Time on Saturday the 27th. You can see details about the entire conference here: http://www.sqlsaturday.com/410/EventHome.aspx 

I am pretty excited about talking about SQL Server In-Memory Technologies, but also it is a bit interesting because of how much SQL Server 2016 is going to change thing. I will do my best to make notes on how it will change the usage and design aspects of In-Memory as I go. You can see a list of how things are changing here in Aaron Bertrand’s blog entry. In 2016, it won’t change the In-Memory OLTP stuff to be general purpose, but it certainly will change how effective it can be used in certain scenarios.

I do wish I had more time to play with 2016 before my presentations, but I don’t believe it would change any of my current opinions on usage (other than having quite a bit more data integrity built in, but I certainly will be testing out the new stuff in the coming months as I work on my set of pre-book blogs.

Load comments

About the author

Louis Davidson

See Profile

Louis is the former editor of Simple-Talk. Prior to that, has was a corporate database developer and data architect for a non-profit organization for 25 years! Louis has been a Microsoft MVP since 2004, and is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.